package cn.edu.lingnan.tourism.mapper;

import cn.edu.lingnan.tourism.pojo.User;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

public interface AdminMapper{
    //根据sid删除路线
    @Select("delete from tab_route where sid=#{sid}")
    public Integer deleteRouteBySid(Integer sid);
    //根据uid删除收藏夹
    @Select("delete from tab_favorite where uid=#{uid}")
    public Integer deleteFavoriteByUid(Integer uid);
    //根据rid删除路线照片
    @Select("delete from tab_route_img where rid=#{rid}")
    public Integer deleteRouteImgByRid(Integer uid);
    //根据rid删除收藏夹
    @Select("delete from tab_favorite where rid=#{rid}")
    public Integer deleteFavoriteByRid(Integer rid);
}
